/*
Navicat MySQL Data Transfer

Source Server         : mysql
Source Server Version : 50723
Source Host           : localhost:3306
Source Database       : mydb3

Target Server Type    : MYSQL
Target Server Version : 50723
File Encoding         : 65001

Date: 2021-12-29 12:27:09
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `bag`
-- ----------------------------
DROP TABLE IF EXISTS `bag`;
CREATE TABLE `bag` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`img`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`introduce`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`type`  int(11) NOT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=9

;

-- ----------------------------
-- Records of bag
-- ----------------------------
BEGIN;
INSERT INTO `bag` VALUES ('1', '没什么用的东西', 'https://img0.baidu.com/it/u=1000811924,1143393954&fm=26&fmt=auto', '不知道有什么用', '1'), ('2', '金创药', 'http://img2.scimg.cn/userupload/auction/cover/1731/orig/201951.jpg?1329468686', '小伤克星', '3'), ('3', '指南针', 'http://mmbiz.qpic.cn/mmbiz/VQo3cNkXlKWVmJmqm7r2kmIB7ENpZ2YkqLznmVu3MrxNJ0nBmEoxmmu9nKv5jhdWqpuibQXbuCaaOMgCic8RYkKw/640?wx_fmt=jpeg', '从此不怕迷失方向', '3'), ('4', '水壶', 'https://p8.itc.cn/images01/20210405/b4d7524667af44a98417eea0eb4ab1f9.png', '渴了就选我,随时随地满血复活', '1'), ('5', '干粮', 'http://bpic.588ku.com/original_pic/19/02/17/365fe1b26b04843694c4a1ff2fb0ec72.jpg', '饿货，来吃东西吧', '3'), ('6', '毛笔', 'http://bpic.588ku.com/element_water_img/19/01/25/02eb7e439d41b73804083d97d1e16d62.jpg', '激情挥洒笔墨吧', '3'), ('7', '宣纸', 'http://5b0988e595225.cdn.sohucs.com/images/20181117/669b9162ca8945f49c3ef7227773de4a.jpeg', '记录美好生活', '3'), ('8', '弯刀', 'http://img1.artron.net/auction/2009/art5801/d/art58010073.jpg', '攻击+20，怪兽退散', '3');
COMMIT;

-- ----------------------------
-- Table structure for `clothes`
-- ----------------------------
DROP TABLE IF EXISTS `clothes`;
CREATE TABLE `clothes` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`img`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`price`  int(11) NOT NULL ,
`stock`  int(11) NOT NULL ,
`introduce`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=9

;

-- ----------------------------
-- Records of clothes
-- ----------------------------
BEGIN;
INSERT INTO `clothes` VALUES ('1', '服装1', 'http://img.alicdn.com/i1/54882540/O1CN01OKu9Wa1UdMYNpIYEk_%21%2154882540.jpg', '16', '0', '温柔的配色，如春日的一抹芬芳，沁人心脾，恰到好处的花样刺绣点缀儒雅可人......'), ('2', '服装2', 'http://img.alicdn.com/i1/94230802/O1CN01uv5nK21HnMF64zosi_%21%2194230802.jpg', '18', '1', '温柔杏色长衫，可以单独外穿也可叠穿褙子，粉蓝的结合更富有层次感......'), ('3', '服装3', 'https://gd1.alicdn.com/imgextra/i3/2350322170/O1CN01rqaPaY1RtuAfplzcg_!!2350322170.jpg', '32', '1', '群花点缀的前襟一眼四季芬芳！整体温柔浅杏色内里一件橙色的抹胸春日气息扑面而来......'), ('4', '服装4', 'https://gd2.alicdn.com/imgextra/i2/411005513/O1CN01GeNoMU1qb0Bemm6WH_!!411005513.jpg', '16', '0', '兰竹君子相遇，蝴蝶在衣身上翩翩起舞！蓝绿渐变裙摆彷如春日阳光下的湖水，整体悠远清新......'), ('5', '服装5', 'https://img.alicdn.com/imgextra/i3/411005513/O1CN01DiU8zQ1qb0Bzi5PVx_!!411005513.jpg', '16', '2', '月白的褙子与杏色的下裙相配清新淡雅，搭配上水红色的宋抹更显得灵动出彩......'), ('6', '服装6', 'https://img.alicdn.com/imgextra/i3/2878066472/O1CN01nbFQsl1xgDyoEu9BV_!!2878066472.jpg', '16', '2', '仙鹤与山川纹的结合，内层是宝蓝的的宋抹与襟相呼应，彰显宋朝文人的儒雅......'), ('7', '服装7', 'https://img.alicdn.com/imgextra/https://img.alicdn.com/imgextra/i4/2835046187/O1CN01HP3NzM1vZh5aTj6dF_!!2835046187.jpg_60x60q90.jpg', '16', '2', '上襦元素选用高雅的兰花元素，褙子绣着山茶和月季，绣花元素相互呼应给人很夏天的感觉......'), ('8', '服装8', 'https://img.alicdn.com/imgextra/https://img.alicdn.com/imgextra/i2/3358098495/O1CN01Nsou2h2CclInMLCDB_!!3358098495.jpg_60x60q90.jpg', '16', '1', '褙子领边和袖口绣着山石，灵芝以及梅松！采用大红色飘带整套设计富贵而不失少女情怀......');
COMMIT;

-- ----------------------------
-- Table structure for `diary`
-- ----------------------------
DROP TABLE IF EXISTS `diary`;
CREATE TABLE `diary` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`content`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`date`  date NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=5

;

-- ----------------------------
-- Records of diary
-- ----------------------------
BEGIN;
INSERT INTO `diary` VALUES ('1', '今天什么都没做', '2021-12-05'), ('2', '今天小翠换了新发型，真可爱', '2021-12-05'), ('3', '今天杂货铺老板坑了我，岂可修', '2021-12-05'), ('4', '测试一下写日记的功能', '2021-12-05');
COMMIT;

-- ----------------------------
-- Table structure for `enemy`
-- ----------------------------
DROP TABLE IF EXISTS `enemy`;
CREATE TABLE `enemy` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`maxHp`  int(11) NULL DEFAULT NULL ,
`atk`  int(11) NULL DEFAULT NULL ,
`def`  int(11) NULL DEFAULT NULL ,
`area`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`skill`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`img`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=8

;

-- ----------------------------
-- Records of enemy
-- ----------------------------
BEGIN;
INSERT INTO `enemy` VALUES ('1', '野猪', '40', '40', '20', '树林', '冲撞', 'https://img2.baidu.com/it/u=1160624782,238485227&fm=15&fmt=auto'), ('2', '野猫', '30', '48', '18', '树林', '疯狂乱抓', 'https://img1.baidu.com/it/u=161714662,4042224038&fm=26&fmt=auto'), ('3', '蛇', '25', '50', '25', '树林', '毒液', 'https://img2.baidu.com/it/u=2878598427,4257394744&fm=26&fmt=auto'), ('4', '兔兔', '30', '32', '10', '树林', '瞪眼', 'https://img1.baidu.com/it/u=3820191068,3517474133&fm=26&fmt=auto'), ('5', '水怪', '50', '55', '25', '沼泽', '吐泥', 'https://img2.baidu.com/it/u=3819405692,134741047&fm=26&fmt=auto'), ('6', '沼泽章鱼', '60', '60', '30', '沼泽', '缠绕', 'https://img2.baidu.com/it/u=1365420680,1359638890&fm=26&fmt=auto'), ('7', '暗影之仆', '100', '40', '20', '沼泽', '诅咒', 'https://img0.baidu.com/it/u=3800473111,4175145366&fm=26&fmt=auto');
COMMIT;

-- ----------------------------
-- Table structure for `furniture`
-- ----------------------------
DROP TABLE IF EXISTS `furniture`;
CREATE TABLE `furniture` (
`id`  int(11) NOT NULL ,
`name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`img`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`introduce`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of furniture
-- ----------------------------
BEGIN;
INSERT INTO `furniture` VALUES ('1', '家具1', 'https://p1.ssl.qhimg.com/t01f06c502f7a0dcec6.jpg', '宋代，垂足而坐的椅、凳等高脚坐具已普及民间，结束了几千年来席地坐的习俗。宋代家具以造型淳朴纤秀、结构合理精细为主要特征。宋代家具还重视外形尺寸和结构与人体的关系，工艺严谨，造型优美，使用方便。'), ('2', '家具2', 'http://0.rc.xiniu.com/g3/M00/5D/D0/CgAH6F8VKf-AEMviAAGu-WhWx50773.jpg', '宋代，垂足而坐的椅、凳等高脚坐具已普及民间，结束了几千年来席地坐的习俗。宋代家具以造型淳朴纤秀、结构合理精细为主要特征。宋代家具还重视外形尺寸和结构与人体的关系，工艺严谨，造型优美，使用方便。'), ('3', '家具3', 'http://img1.artron.net/auction/2014/art505257/d/art5052577659.jpg', '宋代，垂足而坐的椅、凳等高脚坐具已普及民间，结束了几千年来席地坐的习俗。宋代家具以造型淳朴纤秀、结构合理精细为主要特征。宋代家具还重视外形尺寸和结构与人体的关系，工艺严谨，造型优美，使用方便。'), ('4', '家具4', 'https://nimg.ws.126.net/?url=http%3A%2F%2Fdingyue.ws.126.net%2FSGSmUHaKXm4Df15PQuGlHzdBI82PMM8UtmI1jGmDX%3DIdu1556067670070.jpg&thumbnail=650x2147483647&quality=80&type=jpg', '宋代，垂足而坐的椅、凳等高脚坐具已普及民间，结束了几千年来席地坐的习俗。宋代家具以造型淳朴纤秀、结构合理精细为主要特征。宋代家具还重视外形尺寸和结构与人体的关系，工艺严谨，造型优美，使用方便。'), ('5', '家具5', 'http://0.rc.xiniu.com/g2/M00/9C/44/CgAGfFsWBQCAa4YNAAJ8QUvhWRg350.jpg', '宋代，垂足而坐的椅、凳等高脚坐具已普及民间，结束了几千年来席地坐的习俗。宋代家具以造型淳朴纤秀、结构合理精细为主要特征。宋代家具还重视外形尺寸和结构与人体的关系，工艺严谨，造型优美，使用方便。'), ('6', '家具6', 'http://5b0988e595225.cdn.sohucs.com/images/20200417/615c5fa1075548d3a378cd4f917e9926.JPG', '宋代，垂足而坐的椅、凳等高脚坐具已普及民间，结束了几千年来席地坐的习俗。宋代家具以造型淳朴纤秀、结构合理精细为主要特征。宋代家具还重视外形尺寸和结构与人体的关系，工艺严谨，造型优美，使用方便。'), ('7', '家具7', 'https://cos3.solepic.com/20210517/b_900048202105172049056740.jpg', '宋代，垂足而坐的椅、凳等高脚坐具已普及民间，结束了几千年来席地坐的习俗。宋代家具以造型淳朴纤秀、结构合理精细为主要特征。宋代家具还重视外形尺寸和结构与人体的关系，工艺严谨，造型优美，使用方便。'), ('8', '家具8', 'http://img1.artron.net/auction/2014/art505257/d/art5052577659.jpg', '宋代，垂足而坐的椅、凳等高脚坐具已普及民间，结束了几千年来席地坐的习俗。宋代家具以造型淳朴纤秀、结构合理精细为主要特征。宋代家具还重视外形尺寸和结构与人体的关系，工艺严谨，造型优美，使用方便。');
COMMIT;

-- ----------------------------
-- Table structure for `player`
-- ----------------------------
DROP TABLE IF EXISTS `player`;
CREATE TABLE `player` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`maxHp`  int(11) NULL DEFAULT NULL ,
`atk`  int(11) NULL DEFAULT NULL ,
`def`  int(11) NULL DEFAULT NULL ,
`money`  int(11) NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=2

;

-- ----------------------------
-- Records of player
-- ----------------------------
BEGIN;
INSERT INTO `player` VALUES ('1', '200', '30', '20', '200');
COMMIT;

-- ----------------------------
-- Table structure for `product`
-- ----------------------------
DROP TABLE IF EXISTS `product`;
CREATE TABLE `product` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`img`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`price`  int(11) NOT NULL ,
`stock`  int(11) NOT NULL ,
`introduce`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=9

;

-- ----------------------------
-- Records of product
-- ----------------------------
BEGIN;
INSERT INTO `product` VALUES ('1', '金创药', 'http://img2.scimg.cn/userupload/auction/cover/1731/orig/201951.jpg?1329468686', '1288', '0', '治疗+999 妙手回春'), ('2', '指南针', 'http://mmbiz.qpic.cn/mmbiz/VQo3cNkXlKWVmJmqm7r2kmIB7ENpZ2YkqLznmVu3MrxNJ0nBmEoxmmu9nKv5jhdWqpuibQXbuCaaOMgCic8RYkKw/640?wx_fmt=jpeg', '588', '0', '精力+999 指南针在手地图随意跑'), ('3', '干粮', 'http://bpic.588ku.com/original_pic/19/02/17/365fe1b26b04843694c4a1ff2fb0ec72.jpg', '288', '0', '体力+999 即刻满血复活'), ('4', '屠龙宝刀', 'https://img2.baidu.com/it/u=3672918368,3287089533&fm=26&fmt=auto', '999', '1', '攻击+999 传说勇者曾用这把刀打到巨龙'), ('5', '玄武盔甲', 'https://img0.baidu.com/it/u=1622009416,1500189846&fm=26&fmt=auto', '999', '1', '防御+999 用玄武壳制成的坚固护甲'), ('6', '毛笔', 'http://bpic.588ku.com/element_water_img/19/01/25/02eb7e439d41b73804083d97d1e16d62.jpg', '188', '0', '激情挥洒笔墨吧'), ('7', '宣纸', 'http://5b0988e595225.cdn.sohucs.com/images/20181117/669b9162ca8945f49c3ef7227773de4a.jpeg', '188', '0', '记录美好生活就用它'), ('8', '弯刀', 'http://img1.artron.net/auction/2009/art5801/d/art58010073.jpg', '999', '0', '攻击+20 怪兽退散');
COMMIT;

-- ----------------------------
-- Table structure for `thing`
-- ----------------------------
DROP TABLE IF EXISTS `thing`;
CREATE TABLE `thing` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`amount`  int(11) NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=7

;

-- ----------------------------
-- Records of thing
-- ----------------------------
BEGIN;
INSERT INTO `thing` VALUES ('4', '旗帜', '2'), ('5', '沙包', '1'), ('6', '邪箭', '1');
COMMIT;

-- ----------------------------
-- Auto increment value for `bag`
-- ----------------------------
ALTER TABLE `bag` AUTO_INCREMENT=9;

-- ----------------------------
-- Auto increment value for `clothes`
-- ----------------------------
ALTER TABLE `clothes` AUTO_INCREMENT=9;

-- ----------------------------
-- Auto increment value for `diary`
-- ----------------------------
ALTER TABLE `diary` AUTO_INCREMENT=5;

-- ----------------------------
-- Auto increment value for `enemy`
-- ----------------------------
ALTER TABLE `enemy` AUTO_INCREMENT=8;

-- ----------------------------
-- Auto increment value for `player`
-- ----------------------------
ALTER TABLE `player` AUTO_INCREMENT=2;

-- ----------------------------
-- Auto increment value for `product`
-- ----------------------------
ALTER TABLE `product` AUTO_INCREMENT=9;

-- ----------------------------
-- Auto increment value for `thing`
-- ----------------------------
ALTER TABLE `thing` AUTO_INCREMENT=7;
